Skip to main content Skip to complementary content
Qlik Resources

Prerequisites

Before you can use Amazon Redshift as a data warehouse in a Qlik Compose project, make sure that the following prerequisites have been met:

Driver

  • Install and configure the latest Amazon Redshift 64-bit ODBC Driver.

  • Install the Amazon Redshift JDBC Driver on the Compose machine. Amazon are working to resolve a known issue with their latest driver. Until the issue is resolved, JDBC driver 4.1 needs to be used instead.

    1. Download the JAR file from:

      https://mvnrepository.com/artifact/com.amazon.redshift/redshift-jdbc41/1.2.10.1009

    2. Copy it to:

      <Compose_Installation_Folder>\java\jdbc

Information note

The Qlik Compose service needs to be restarted after copying the driver.

Amazon Redshift Cluster

If you haven't already done so, set up an Amazon Redshift cluster and make sure that following information about your Amazon Redshift Cluster is readily available:

  • Amazon Redshift Cluster Name
  • Amazon Redshift Cluster Port
  • Amazon Redshift User Name and Password
  • Amazon Redshift Database Name

Permissions

Qlik Replicate performs the following operations on the replicated tables within Amazon Redshift:

  • SELECT, INSERT, UPDATE and DELETE
  • Bulk Load
  • CREATE, ALTER, DROP
  • CREATE VIEW

If the user is the 'DB Owner', these permissions are in place by default. Otherwise, the user must be granted these permissions to achieve successful replication.

Port

Make sure that port 5439 (the Amazon Redshift Cluster port) is open for inbound connections from Qlik Compose .

Did this page help you?

If you find any issues with this page or its content – a typo, a missing step, or a technical error – let us know how we can improve!

Leave your feedback here